﻿CREATE PROCEDURE [dbo].[proc_Notice_GetList_GroupTop]

AS
	Begin
	select * from (
		Select
			top 5
			N.Id,
			N.NId,
			N.Fid,
			(select title from notice_category where id=N.fid) as category,
			N.Title,
			N.Content,
			N.UpName,
			N.IsAll,
			N.IsDing,
			N.CreateTime,
			N.UpTime 
		From Notice N Where IsAll=1 Order By CreateTime DESC) as a
		order by IsDing DESC
		
	End
	RETURN
